SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwlLiquidacionByPl
AS
SELECT dbo.tb_LiquidacionBYP.idLiquidacionByP AS Id, dbo.tb_LiquidacionBYP.Descripcion, dbo.tb_LiquidacionBYP.Año, dbo.tb_LiquidacionBYP.Pagado, 
               dbo.vwrLineasDeBYP.Descripcion AS Linea, dbo.tb_LiquidacionBYP.IdLineaDeByP, dbo.tb_LiquidacionBYP.NumeroPeriodo
FROM  dbo.vwrLineasDeBYP INNER JOIN
               dbo.tb_LiquidacionBYP ON dbo.vwrLineasDeBYP.Id = dbo.tb_LiquidacionBYP.IdLineaDeByP
GO
GRANT SELECT ON  [dbo].[vwlLiquidacionByPl] TO [Becas]
GRANT SELECT ON  [dbo].[vwlLiquidacionByPl] TO [SoloVer]
GO
